CREATE VIEW [dbo].[vRegistrationStatusChangeGrouped]
AS
SELECT RSC1.[RegistrationStatusChangeKey]
  FROM [dbo].[RegistrationStatusChange] AS RSC1
WHERE RSC1.[UpdatedOn] =  ( SELECT MAX(RSC2.UpdatedOn)
                                     FROM [dbo].[RegistrationStatusChange] AS RSC2
                                    WHERE RSC1.[CertificationProgramRegistrationKey] = RSC2.[CertificationProgramRegistrationKey] )

GO